package com.Lgwd.repository;

import com.Lgwd.entity.ItemPropertyEntity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

@Repository
public interface ItemPropertyRepository extends JpaRepository<ItemPropertyEntity,Integer> {




    @Query(value="select * FROM `itemproperty` where item_code_id=?1" , nativeQuery = true)
    ItemPropertyEntity findByItem_code_id(@Param("item_code_id")Integer itemCodeId);
}
